************************************************************
*A Replication of The Robust Relationship between Taxes and*
*US State Income Growth (NTJ 2008): Tables Replication     *
************************************************************
	clear
	set more off
	*set directory to wherever data is saved
	cd ""
	use RobustRelationshipBetweenTaxesandStateIncomeGrowth_ReplicationData.dta

	*get rid of AK, HI, DC
	drop if stfips==150|stfips==950|stfips==1100	

	*gen GKR pop weight
	by stfips: egen avgpop=mean(TotalPop)	
	
	*********
	*Table 1*
	*********
		eststo clear
		
		*Column 1: Reed's #'s
			*From Table 1, column 5 on page 62
		
		*Column 2: Replicate Reed
			preserve
				keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999
				eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust	
			restore			

			preserve
				keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999
				eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust cluster(stfips)				
			restore			
		
		*Column 3: Add Population Weights
			preserve
				keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999
				eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop], robust		
			restore			
		
			preserve
				keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999
				eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop], robust	cluster(stfips)			
			restore			
		
	*********
	*Table 2*
	*********	
		*panel 1
		*1970-1999	
		preserve
			keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore			
	
		*1971-2000
		preserve
			keep if year==1975|year==1980|year==1985|year==1990|year==1995|year==2000			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore	
		
		*1972-2001
		preserve
			keep if year==1976|year==1981|year==1986|year==1991|year==1996|year==2001			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore			
		
		*1975-1999
		preserve
			keep if year==1979|year==1984|year==1989|year==1994|year==1999			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore		
		
		*1976-2000
		preserve
			keep if year==1980|year==1985|year==1990|year==1995|year==2000			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore	
		
		*1977-2001
		preserve
			keep if year==1981|year==1986|year==1991|year==1996|year==2001		
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore		
		
		*panel 2
		*1970-2004
		preserve
			keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999|year==2004		
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore	
		
		*1971-2005
		preserve
			keep if year==1975|year==1980|year==1985|year==1990|year==1995|year==2000|year==2005	
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore		
				
		*1972-2006
		preserve
			keep if year==1976|year==1981|year==1986|year==1991|year==1996|year==2001|year==2006		
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore		
		
		*1975-2004
		preserve
			keep if year==1979|year==1984|year==1989|year==1994|year==1999|year==2004		
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore		
		
		*1976-2005
		preserve
			keep if year==1980|year==1985|year==1990|year==1995|year==2000|year==2005			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore	
		
		*1977-2006
		preserve
			keep if year==1981|year==1986|year==1991|year==1996|year==2001|year==2006
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore	
		
		*panel 3
		*1970-2009
		preserve
			keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999|year==2004|year==2009
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore	
		
		*1971-2010
		preserve
			keep if year==1975|year==1980|year==1985|year==1990|year==1995|year==2000|year==2005|year==2010
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore		
				
		*1972-2011
		preserve
			keep if year==1976|year==1981|year==1986|year==1991|year==1996|year==2001|year==2006|year==2011			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore		
		
		*1975-2009
		preserve
			keep if year==1979|year==1984|year==1989|year==1994|year==1999|year==2004|year==2009			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore		
		
		*1976-2010
		preserve
			keep if year==1980|year==1985|year==1990|year==1995|year==2000|year==2005|year==2010			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore	
		
		*1977-2011
		preserve
			keep if year==1981|year==1986|year==1991|year==1996|year==2001|year==2006|year==2011			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore	
		
		*panel 4
		*1970-2014
		preserve
			keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999|year==2004|year==2009|year==2014		
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore	
		
		*1971-2015
		preserve
			keep if year==1975|year==1980|year==1985|year==1990|year==1995|year==2000|year==2005|year==2010|year==2015			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore		
				
		*1972-2016
		preserve
			keep if year==1976|year==1981|year==1986|year==1991|year==1996|year==2001|year==2006|year==2011|year==2016			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore		
		
		*1975-2014
		preserve
			keep if year==1979|year==1984|year==1989|year==1994|year==1999|year==2004|year==2009|year==2014			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore		
		
		*1976-2015
		preserve
			keep if year==1980|year==1985|year==1990|year==1995|year==2000|year==2005|year==2010|year==2015			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore	
		
		*1977-2016
		preserve
			keep if year==1981|year==1986|year==1991|year==1996|year==2001|year==2006|year==2011|year==2016			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year, robust
		restore			
		
	*********
	*Table 3*
	*********			
		eststo clear
		local Column1Controls Education_D Education_L WorkingPop_D WorkingPop_L ///
		Nonwhite_D Nonwhite_L Female_D Female_L lnpop PopDensity_D PopDensity_L ///
		Urban_D Urban_L Agriculture_D Agriculture_L Manufacturing_D Manufacturing_L ///
		Service_D Service_L Mining_D Mining_L Union_D Union_L Diversity_D Diversity_L ///
		LNY_1_Real	
	
		*panel 1
		*1970-1999
		preserve
			keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999	
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore			
	
		*1971-2000
		preserve
			keep if year==1975|year==1980|year==1985|year==1990|year==1995|year==2000
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore	
		
		*1972-2001
		preserve
			keep if year==1976|year==1981|year==1986|year==1991|year==1996|year==2001
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore			
		
		*1975-1999
		preserve
			keep if year==1979|year==1984|year==1989|year==1994|year==1999
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore		
		
		*1976-2000
		preserve
			keep if year==1980|year==1985|year==1990|year==1995|year==2000
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore	
		
		*1977-2001
		preserve
			keep if year==1981|year==1986|year==1991|year==1996|year==2001
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore		
		
		*panel 2
		*1970-2004
		preserve
			keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999|year==2004
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore	
		
		*1971-2005
		preserve
			keep if year==1975|year==1980|year==1985|year==1990|year==1995|year==2000|year==2005
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore		
				
		*1972-2006
		preserve
			keep if year==1976|year==1981|year==1986|year==1991|year==1996|year==2001|year==2006
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore		
		
		*1975-2004
		preserve
			keep if year==1979|year==1984|year==1989|year==1994|year==1999|year==2004
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore		
		
		*1976-2005
		preserve
			keep if year==1980|year==1985|year==1990|year==1995|year==2000|year==2005
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore	
		
		*1977-2006
		preserve
			keep if year==1981|year==1986|year==1991|year==1996|year==2001|year==2006
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore	
		
		*panel 3
		*1970-2009
		preserve
			keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999|year==2004|year==2009
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore	
		
		*1971-2010
		preserve
			keep if year==1975|year==1980|year==1985|year==1990|year==1995|year==2000|year==2005|year==2010
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore		
				
		*1972-2011
		preserve
			keep if year==1976|year==1981|year==1986|year==1991|year==1996|year==2001|year==2006|year==2011
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore		
		
		*1975-2009
		preserve
			keep if year==1979|year==1984|year==1989|year==1994|year==1999|year==2004|year==2009
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore		
		
		*1976-2010
		preserve
			keep if year==1980|year==1985|year==1990|year==1995|year==2000|year==2005|year==2010
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore	
		
		*1977-2011
		preserve
			keep if year==1981|year==1986|year==1991|year==1996|year==2001|year==2006|year==2011
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore	
		
		*panel 4
		*1970-2014
		preserve
			keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999|year==2004|year==2009|year==2014
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore	
		
		*1971-2015
		preserve
			keep if year==1975|year==1980|year==1985|year==1990|year==1995|year==2000|year==2005|year==2010|year==2015			
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore		
				
		*1972-2016
		preserve
			keep if year==1976|year==1981|year==1986|year==1991|year==1996|year==2001|year==2006|year==2011|year==2016			
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore		
		
		*1975-2014
		preserve
			keep if year==1979|year==1984|year==1989|year==1994|year==1999|year==2004|year==2009|year==2014			
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore		
		
		*1976-2015
		preserve
			keep if year==1980|year==1985|year==1990|year==1995|year==2000|year==2005|year==2010|year==2015			
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore	
		
		*1977-2016
		preserve
			keep if year==1981|year==1986|year==1991|year==1996|year==2001|year==2006|year==2011|year==2016			
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log  TaxBurden_D TaxBurden_L `Column1Controls' i.stfips i.year, robust
		restore			
			
	*********
	*Table 4*
	*********			
		*creating time tax burden interactions
		forv a = 1974(5)2014 {
			gen break_`a'=0
			replace break_`a'=1 if year>`a'
		}
		forv a = 1975(5)2015 {
			gen break_`a'=0
			replace break_`a'=1 if year>`a'
		}		
		forv a = 1976(5)2016 {
			gen break_`a'=0
			replace break_`a'=1 if year>`a'
		}	
		
		local taxvars TaxBurden_D TaxBurden_L
		foreach a of local taxvars {
			forv b = 1974(5)2014 {
				gen `a'_`b' = `a'*break_`b'
			}
		}
		local taxvars TaxBurden_D TaxBurden_L 
		foreach a of local taxvars {
			forv b = 1975(5)2015 {
				gen `a'_`b' = `a'*break_`b'
			}
		}		
		local taxvars TaxBurden_D TaxBurden_L 
		foreach a of local taxvars {
			forv b = 1976(5)2016 {
				gen `a'_`b' = `a'*break_`b'
			}
		}				
			
		eststo clear
			
		*Column 1
		*Reduced Form: Short-run & Long-run
		preserve
			keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999|year==2004|year==2009|year==2014			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L TaxBurden_D_1994 TaxBurden_L_1994 i.stfips i.year, robust
			test TaxBurden_D + TaxBurden_D_1994=0							
			sca sum = _b[TaxBurden_D] + _b[TaxBurden_D_1994]				
			di sum
			test TaxBurden_L + TaxBurden_L_1994=0
			sca sum = _b[TaxBurden_L] + _b[TaxBurden_L_1994]
			di sum					
		restore	
			
		*Structural Form: Short-run & Long-run
		preserve
			keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999|year==2004|year==2009|year==2014			
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log `Column1Controls' TaxBurden_D TaxBurden_L TaxBurden_D_1994 TaxBurden_L_1994 i.stfips i.year, robust
			test TaxBurden_D + TaxBurden_D_1994=0
			sca sum = _b[TaxBurden_D] + _b[TaxBurden_D_1994]
			di sum		
			test TaxBurden_L + TaxBurden_L_1994=0
			sca sum = _b[TaxBurden_L] + _b[TaxBurden_L_1994]
			di sum					
		restore	
				
		*Column 2
		*Reduced Form: Short-run & Long-run
		preserve
			keep if year==1975|year==1980|year==1985|year==1990|year==1995|year==2000|year==2005|year==2010|year==2015			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L TaxBurden_D_1995 TaxBurden_L_1995 i.stfips i.year, robust
			test TaxBurden_D + TaxBurden_D_1995=0							
			sca sum = _b[TaxBurden_D] + _b[TaxBurden_D_1995]				
			di sum
			test TaxBurden_L + TaxBurden_L_1995=0
			sca sum = _b[TaxBurden_L] + _b[TaxBurden_L_1995]
			di sum					
		restore	
			
		*Structural Form: Short-run & Long-run
		preserve
			keep if year==1975|year==1980|year==1985|year==1990|year==1995|year==2000|year==2005|year==2010|year==2015		
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log `Column1Controls' TaxBurden_D TaxBurden_L TaxBurden_D_1995 TaxBurden_L_1995 i.stfips i.year, robust
			test TaxBurden_D + TaxBurden_D_1995=0
			sca sum = _b[TaxBurden_D] + _b[TaxBurden_D_1995]
			di sum		
			test TaxBurden_L + TaxBurden_L_1995=0
			sca sum = _b[TaxBurden_L] + _b[TaxBurden_L_1995]
			di sum					
		restore				
			
		*Column 3
		*Reduced Form: Short-run & Long-run
		preserve
			keep if year==1976|year==1981|year==1986|year==1991|year==1996|year==2001|year==2006|year==2011|year==2016		
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L TaxBurden_D_1996 TaxBurden_L_1996 i.stfips i.year, robust
			test TaxBurden_D + TaxBurden_D_1996=0							
			sca sum = _b[TaxBurden_D] + _b[TaxBurden_D_1996]				
			di sum
			test TaxBurden_L + TaxBurden_L_1996=0
			sca sum = _b[TaxBurden_L] + _b[TaxBurden_L_1996]
			di sum					
		restore	
			
		*Structural Form: Short-run & Long-run
		preserve
			keep if year==1976|year==1981|year==1986|year==1991|year==1996|year==2001|year==2006|year==2011|year==2016		
			eststo: reg DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log `Column1Controls' TaxBurden_D TaxBurden_L TaxBurden_D_1996 TaxBurden_L_1996 i.stfips i.year, robust
			test TaxBurden_D + TaxBurden_D_1996=0
			sca sum = _b[TaxBurden_D] + _b[TaxBurden_D_1996]
			di sum		
			test TaxBurden_L + TaxBurden_L_1996=0
			sca sum = _b[TaxBurden_L] + _b[TaxBurden_L_1996]
			di sum					
		restore		
		
	******************
	*Appendix Table 1*
	******************
		*Column 1 Reed's (Pages 65 and 80)
			sca DLNY_Log_RealC1_mean = 8.23
			sca DLNY_Log_RealC1_sd = 5.20
			sca DLNY_Log_RealC1_min = -9.38
			sca DLNY_Log_RealC1_max = 40.55
			sca DLNK_LogC1_mean = 7.42
			sca DLNK_LogC1_sd = 7.81
			sca DLNK_LogC1_min = -26.92
			sca DLNK_LogC1_max = 55.43		
			sca DLNL_LogC1_mean = 4.66
			sca DLNL_LogC1_sd = 3.99
			sca DLNL_LogC1_min = -7.22
			sca DLNL_LogC1_max = 14.97			
			sca DLNN_LogC1_mean = 4.63
			sca DLNN_LogC1_sd = 4.48
			sca DLNN_LogC1_min = -8.63
			sca DLNN_LogC1_max = 21.45	
			sca TaxBurden_DC1_mean = 0.13
			sca TaxBurden_DC1_sd = 0.88
			sca TaxBurden_DC1_min = -5.52
			sca TaxBurden_DC1_max = 5.91
			sca TaxBurden_LC1_mean = 10.87
			sca TaxBurden_LC1_sd = 1.37
			sca TaxBurden_LC1_min = 7.92
			sca TaxBurden_LC1_max = 19.27			
			sca Education_DC1_mean = 1.77
			sca Education_DC1_sd = 0.55
			sca Education_DC1_min = 0.34
			sca Education_DC1_max = 3.21
			sca Education_LC1_mean = 16.41
			sca Education_LC1_sd = 4.92
			sca Education_LC1_min = 6.66
			sca Education_LC1_max = 30.21
			sca WorkingPop_DC1_mean = 0.97
			sca WorkingPop_DC1_sd = 0.93
			sca WorkingPop_DC1_min = -1.22
			sca WorkingPop_DC1_max = 2.93
			sca WorkingPop_LC1_mean = 55.84
			sca WorkingPop_LC1_sd = 3.18
			sca WorkingPop_LC1_min = 47.54
			sca WorkingPop_LC1_max = 62.26			
			sca Nonwhite_DC1_mean = 0.56
			sca Nonwhite_DC1_sd = 0.51
			sca Nonwhite_DC1_min = -0.98
			sca Nonwhite_DC1_max = 2.42
			sca Nonwhite_LC1_mean = 11.75
			sca Nonwhite_LC1_sd = 8.76
			sca Nonwhite_LC1_min = 0.36
			sca Nonwhite_LC1_max = 37.35	
			sca Female_DC1_mean = -0.02
			sca Female_DC1_sd = 0.15
			sca Female_DC1_min = -0.57
			sca Female_DC1_max = 0.75
			sca Female_LC1_mean = 51.23
			sca Female_LC1_sd = 0.77
			sca Female_LC1_min = 48.77
			sca Female_LC1_max = 52.76	
			sca lnpopC1_mean = 14.93
			sca lnpopC1_sd = 1.00
			sca lnpopC1_min = 12.72
			sca lnpopC1_max = 17.27
			sca PopDensity_DC1_mean = 4.93
			sca PopDensity_DC1_sd = 6.68
			sca PopDensity_DC1_min = -8.84
			sca PopDensity_DC1_max = 37.26
			sca PopDensity_LC1_mean = 162.25
			sca PopDensity_LC1_sd = 230.78
			sca PopDensity_LC1_min = 3.44
			sca PopDensity_LC1_max = 1089.83	
			sca Urban_DC1_mean = 0.75
			sca Urban_DC1_sd = 1.13
			sca Urban_DC1_min = -1.97
			sca Urban_DC1_max = 3.96
			sca Urban_LC1_mean = 67.18
			sca Urban_LC1_sd = 14.43
			sca Urban_LC1_min = 32.16
			sca Urban_LC1_max = 93.54	
			sca Agriculture_DC1_mean = -0.06
			sca Agriculture_DC1_sd = 2.46
			sca Agriculture_DC1_min = -16.72
			sca Agriculture_DC1_max = 18.85
			sca Agriculture_LC1_mean = 3.28
			sca Agriculture_LC1_sd = 3.98
			sca Agriculture_LC1_min = -8.92
			sca Agriculture_LC1_max = 29.06				
			sca Manufacturing_DC1_mean = -0.81
			sca Manufacturing_DC1_sd = 1.68
			sca Manufacturing_DC1_min = -6.09
			sca Manufacturing_DC1_max = 3.37
			sca Manufacturing_LC1_mean = 20.93
			sca Manufacturing_LC1_sd = 8.42
			sca Manufacturing_LC1_min = 3.73
			sca Manufacturing_LC1_max = 40.49					
			sca Service_DC1_mean = 1.47
			sca Service_DC1_sd = 1.25
			sca Service_DC1_min = -3.22
			sca Service_DC1_max = 6.40
			sca Service_LC1_mean = 19.51
			sca Service_LC1_sd = 5.65
			sca Service_LC1_min = 10.93
			sca Service_LC1_max = 41.55			
			sca Mining_DC1_mean = -0.19
			sca Mining_DC1_sd = 0.76
			sca Mining_DC1_min = -3.29
			sca Mining_DC1_max = 4.27
			sca Mining_LC1_mean = 2.15
			sca Mining_LC1_sd = 3.53
			sca Mining_LC1_min = 0.02
			sca Mining_LC1_max = 24.98			
			sca Union_DC1_mean = -1.47
			sca Union_DC1_sd = 2.36
			sca Union_DC1_min = -10.60
			sca Union_DC1_max = 5.00
			sca Union_LC1_mean = 18.48
			sca Union_LC1_sd = 8.12
			sca Union_LC1_min = 3.30
			sca Union_LC1_max = 41.70	
			sca Diversity_DC1_mean = -0.06
			sca Diversity_DC1_sd = 0.77
			sca Diversity_DC1_min = -5.42
			sca Diversity_DC1_max = 4.66
			sca Diversity_LC1_mean = 17.36
			sca Diversity_LC1_sd = 2.05
			sca Diversity_LC1_min = 13.84
			sca Diversity_LC1_max = 23.56	
			sca LNY_1_RealC1_mean = 2.53
			sca LNY_1_RealC1_sd = 0.20
			sca LNY_1_RealC1_min = 1.96
			sca LNY_1_RealC1_max = 3.06			
		
		*Column 2 Ours 1970-1999 
		preserve
			keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999			
			local vars DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log TaxBurden_D TaxBurden_L ///
			`Column1Controls'
			foreach a of local vars {
				rename `a' `a'C2
			}
			foreach a of local vars {
				summ `a'C2, detail
				sca `a'C2_mean = r(mean)
				sca `a'C2_sd = r(sd)
				sca `a'C2_min = r(min)
				sca `a'C2_max = r(max)
			}				
		restore 
		
		*Column 3 Ours 1970-2014	
		preserve
			keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999| ///
			year==2004|year==2009|year==2014
			local vars DLNY_Log_Real DLNK_Log DLNL_Log DLNN_Log TaxBurden_D TaxBurden_L ///
			`Column1Controls'
			foreach a of local vars {
				rename `a' `a'C3
			}			
			foreach a of local vars {
				summ `a'C3, detail
				sca `a'C3_mean = r(mean)
				sca `a'C3_sd = r(sd)
				sca `a'C3_min = r(min)
				sca `a'C3_max = r(max)
			}		
		restore		
		
	******************
	*Appendix Table 2*
	******************
		eststo clear
		*panel 1
		*1970-1999
		preserve
			keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999	
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore			
	
		*1971-2000
		preserve
			keep if year==1975|year==1980|year==1985|year==1990|year==1995|year==2000		
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore	
		
		*1972-2001
		preserve
			keep if year==1976|year==1981|year==1986|year==1991|year==1996|year==2001
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore			
		
		*1975-1999
		preserve
			keep if year==1979|year==1984|year==1989|year==1994|year==1999			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore		
		
		*1976-2000
		preserve
			keep if year==1980|year==1985|year==1990|year==1995|year==2000		
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore	
		
		*1977-2001
		preserve
			keep if year==1981|year==1986|year==1991|year==1996|year==2001	
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore		
		
	*panel 2
		*1970-2004
		preserve
			keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999|year==2004
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore	
		
		*1971-2005
		preserve
			keep if year==1975|year==1980|year==1985|year==1990|year==1995|year==2000|year==2005
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore		
				
		*1972-2006
		preserve
			keep if year==1976|year==1981|year==1986|year==1991|year==1996|year==2001|year==2006
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore		
		
		*1975-2004
		preserve
			keep if year==1979|year==1984|year==1989|year==1994|year==1999|year==2004			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore		
		
		*1976-2005
		preserve
			keep if year==1980|year==1985|year==1990|year==1995|year==2000|year==2005
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore	
		
		*1977-2006
		preserve
			keep if year==1981|year==1986|year==1991|year==1996|year==2001|year==2006
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore	
		
	*panel 3
		*1970-2009
		preserve
			keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999|year==2004|year==2009			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore	
		
		*1971-2010
		preserve
			keep if year==1975|year==1980|year==1985|year==1990|year==1995|year==2000|year==2005|year==2010			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore		
				
		*1972-2011
		preserve
			keep if year==1976|year==1981|year==1986|year==1991|year==1996|year==2001|year==2006|year==2011			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore		
		
		*1975-2009
		preserve
			keep if year==1979|year==1984|year==1989|year==1994|year==1999|year==2004|year==2009			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore		
		
		*1976-2010
		preserve
			keep if year==1980|year==1985|year==1990|year==1995|year==2000|year==2005|year==2010			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore	
		
		*1977-2011
		preserve
			keep if year==1981|year==1986|year==1991|year==1996|year==2001|year==2006|year==2011			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore	
		
	*panel 4
		*1970-2014
		preserve
			keep if year==1974|year==1979|year==1984|year==1989|year==1994|year==1999|year==2004|year==2009|year==2014			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore	
		
		*1971-2015
		preserve
			keep if year==1975|year==1980|year==1985|year==1990|year==1995|year==2000|year==2005|year==2010|year==2015			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore		
				
		*1972-2016
		preserve
			keep if year==1976|year==1981|year==1986|year==1991|year==1996|year==2001|year==2006|year==2011|year==2016			
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore		
		
		*1975-2014
		preserve
			keep if year==1979|year==1984|year==1989|year==1994|year==1999|year==2004|year==2009|year==2014		
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore		
		
		*1976-2015
		preserve
			keep if year==1980|year==1985|year==1990|year==1995|year==2000|year==2005|year==2010|year==2015		
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore	
		
		*1977-2016
		preserve
			keep if year==1981|year==1986|year==1991|year==1996|year==2001|year==2006|year==2011|year==2016		
			eststo: reg DLNY_Log_Real TaxBurden_D TaxBurden_L i.stfips i.year [w=avgpop],robust
		restore				
